Notice: Undefined index: exam_geven in /home/ksv69uw2i08d/public_html/onlineexam/exam.php on line 18
ORACLE DBA Online Examination
Sreejobs Logo
   For Latest Job Updates  
 sreenutech.com Online Exams
Home Govt Jobs IT Fresher Jobs IT Exp Jobs IT Walk-Ins MBA Jobs BPO Jobs Register FAQ’s Post Job Contact Us
Search:
SreeJob Fees   Job Feeds
Hot Jobs
Welcome Guest
Login | Register
Total No Of Questions: 100.
1) Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)


2) You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)


3) You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.)


4) You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted?(Choose two.)


5) For which database operation would you need the database to be in the MOUNT state?


6) Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?(Choose two.)


7) The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single product and every product is identified by a product code, which is the primary key. As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products, the company deals with many new products during every quarter.Which method is best suited for this quarterly data transfer?


8) Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)


9) Note the following functionalities of various background processes: 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process?


10) In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table along with the user information. What action would you take to achieve this task?

Notice: Undefined offset: 100 in /home/ksv69uw2i08d/public_html/onlineexam/exam.php on line 418
Page 1 of 10
Home | Register for Job Updates | Contact Us